Bill of Materials Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
GLAcctCode pGLAcctCode 2      
GLInventoryLabour pGlAcct 40      
GLInventoryAppliedLabour pGlAcct 40      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BmBomId int 4      
BmItemId pItemID 24      
BmLocId pLocID 10      
Descr nvarchar 35      
LaborCost pDec 13 0    
UsrFldTxt1 nvarchar 12      
UsrFldTxt2 nvarchar 12      
UsrFldTxt3 nvarchar 12      
UsrFldTxt4 nvarchar 12      
UsrFldTxt5 nvarchar 12      
UsrFldCst1 nvarchar 12      
UsrFldCst2 nvarchar 12      
UsrFldCst3 nvarchar 12      
UsrFldCst4 nvarchar 12      
UsrFldCst5 nvarchar 12      
Uom pUom 5      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BmBomId int 4      
BmDetailType tinyint 1   Item / Subassembly Flag 1 = Item, 2 = Sub
ItemId pItemID 24      
LocId pLocID 10      
Quantity pDec 13      
Uom pUom 5      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
HistSeqNum int 4      
BmBomId int 4      
BmDetailType tinyint 1   Item / Subassembly Flag 1 = Item, 2 = Sub
ItemId pItemID 24      
LocId pLocID 10      
Quantity pDec 13      
Uom pUom 5      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
HistSeqNum int 4      
BmBomId int 4      
BmItemId pItemID 24      
BmLocId pLocID 10      
Descr nvarchar 35      
Status tinyint 1      
LaborCost pDec 13      
UsrFldTxt1 nvarchar 12      
UsrFldTxt2 nvarchar 12      
UsrFldTxt3 nvarchar 12      
UsrFldTxt4 nvarchar 12      
UsrFldTxt5 nvarchar 12      
UsrFldCst1 nvarchar 12      
UsrFldCst2 nvarchar 12      
UsrFldCst3 nvarchar 12      
UsrFldCst4 nvarchar 12      
UsrFldCst5 nvarchar 12      
Update nvarchar 9      
UserId pUserID 20      
Uom pUom 5      
Period smallint 2      
Year smallint 2      
UpdateDate datetime 8      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BmBomId int 4      
Instructions text 16      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
HistSeqNum int 4      
EntryNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
ItemType tinyint 1 0 Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item
LottedYN bit 1 0    
Uom pUom 5      
ConvFactor pDec 13 -1    
Qty pDec 13 0    
UnitCost pDec 13 0    
UnitPrice pDec 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
HistSeqNum int 4      
EntryNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
QtyTrans pDec 13 0    
CostUnit pDec 13 0    
PriceUnit pDec 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
HistSeqNum int 4 0    
EntryNumber int 4 0    
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDec 13 0    
PriceUnit pDec 13 0    
CF xml -1      
ts timestamp 8      
ExtLocAID varchar 10      
ExtLocBID varchar 10      
Column Name Column Type Length Default Value Description Enumeration
HistSeqNum int 4      
BmBomId int 4      
ItemId nvarchar 24      
LocId nvarchar 10      
SumYear smallint 2 0    
SumPeriod smallint 2 0    
GLPeriod smallint 2 0    
BatchId nvarchar 10      
TransId nvarchar 10      
SrceID nvarchar 10      
Uom nvarchar 5      
ConvFactor pDec 13 -1    
Qty pDec 13 0    
Cost pDec 13 0    
Price pDec 13 0    
CustId nvarchar 10      
TransDate datetime 8      
Counter int 4      
InvcNum nvarchar 15      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4 (-1)    
TransDate datetime 8 getdate()    
WorkType tinyint 1 -1 Work Order Type 1 = Build, 2 = Unbuild
Status tinyint 1 0 Work Order Status 0 = Issued, 1 = Confirmed
PrintedYn bit 1 0    
BmBomId int 4      
ItemId pItemID 24      
LocId pLocID 10      
ItemType tinyint 1   Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized
BuildUOM pUom 5      
BuildQty pDec 13 0    
ActualQty pDec 13 0    
LaborCost pDec 13 0    
UnitCost pDec 13 0    
ConvFactor pDec 13 -1    
GLPeriod smallint 2 0    
GlYear smallint 2 0    
SumHistPeriod smallint 2 0    
QtySeqNum int 4 0    
HistSeqNum int 4 0    
WorkUser pUserID 20      
CF xml -1      
ts timestamp 8      
*ExtLocA int        
*ExtLocB int        
*QtySeqNum_Ext int        
*QtyStatus int        
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4 0    
ItemId pItemID 24      
LocId pLocID 10      
ItemType tinyint 1   Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized
OriCompQty pDec 13 0    
EstQty pDec 13 0    
ActQty pDec 13 0    
Uom pUom 5      
ConvFactor pDec 13 -1    
UnitCost pDec 13 0    
QtySeqNum int 4 0    
HistSeqNum int 4 0    
CF xml -1      
ts timestamp 8      
*ExtLocA int        
*ExtLocB int        
*QtySeqNum_Ext int        
*QtyStatus int        
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
TransId pTransID 8      
EntryNum int 4 (-1)    
TransDate datetime 8 getdate()    
WorkType tinyint 1 -1 Work Order Type 1 = Build, 2 = Unbuild
Status tinyint 1 0 Work Order Status 0 = Issued, 1 = Confirmed
PrintedYn bit 1 0    
BmBomId int 4      
ItemId pItemID 24      
LocId pLocID 10      
ItemType tinyint 1   Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized
BuildUOM pUom 5      
BuildQty pDec 13 0    
ActualQty pDec 13 0    
LaborCost pDec 13 0    
UnitCost pDec 13 0    
ConvFactor pDec 13 -1    
GLPeriod smallint 2 0    
GlYear smallint 2 0    
SumHistPeriod smallint 2 0    
QtySeqNum int 4 0    
HistSeqNum int 4 0    
WorkUser pUserID 20      
Descr nvarchar 35      
UomBase pUom 5      
ItemStatus tinyint 1   Item Status 1 = Active, 2 = Discontinued, 3 = Superseded, 4 = Obsolete
ItemLocStatus tinyint 1   Item Location Status 1 = Active, 2 = Discontinued, 3 = Superseded, 4 = Obsolete
GLAcctCode pGLAcctCode 2      
CF xml -1      
ts timestamp 8      
*ExtLocAID nvarchar 10      
*ExtLocBID nvarchar 10      
*QtySeqNum_Ext int        
*QtyStatus int        
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
TransId pTransID 8      
EntryNum int 4 0    
ItemId pItemID 24      
LocId pLocID 10      
ItemType tinyint 1   Item Type 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized
OriCompQty pDec 13 0    
EstQty pDec 13 0    
ActQty pDec 13 0    
Uom pUom 5      
ConvFactor pDec 13 -1    
UnitCost pDec 13 0    
QtySeqNum int 4 0    
HistSeqNum int 4 0    
CF xml -1      
ts timestamp 8      
*ExtLocAID nvarchar 10      
*ExtLocBID nvarchar 10      
*QtySeqNum_Ext int        
*QtyStatus int        
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
TransId pTransID 8      
EntryNum int 4 0    
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
QtyOrder pDec 13 0    
QtyFilled pDec 13 0    
QtyBkord pDec 13 0    
CostUnit pDec 13 0    
CostUnitFgn pDec 13 0    
HistSeqNum int 4 0    
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
*ExtLocAID nvarchar 10      
*ExtLocBID nvarchar 10      
*QtySeqNum_Ext int        
*QtyStatus int        
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun 14 0    
TransId pTransID 8      
EntryNum int 4 0    
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDec 13 0    
CostUnitFgn pDec 13 0    
PriceUnit pDec 13 0    
PriceUnitFgn pDec 13 0    
HistSeqNum int 4 0    
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
ExtLocAID varchar 10      
ExtLocBID varchar 10      
*CostUnitACV pDec 13      
*QtyStatus int        
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4 0    
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
QtyOrder pDec 13 0    
QtyFilled pDec 13 0    
QtyBkord pDec 13 0    
CostUnit pDec 13 0    
CostUnitFgn pDec 13 0    
HistSeqNum int 4 0    
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
*ExtLocA int        
*ExtLocB int        
*QtySeqNum_Ext int        
*QtyStatus int        
Column Name Column Type Length Default Value Description Enumeration
TransId pTransID 8      
EntryNum int 4 0    
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
CostUnit pDec 13 0    
CostUnitFgn pDec 13 0    
PriceUnit pDec 13 0    
PriceUnitFgn pDec 13 0    
HistSeqNum int 4 0    
Cmnt nvarchar 35      
QtySeqNum int 4 0    
CF xml -1      
ts timestamp 8      
ExtLocA int 4      
ExtLocB int 4      
*QtyStatus int